/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package py.com.davweb;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.DropDown;
import com.sun.webui.jsf.component.TextField;
import com.sun.webui.jsf.model.Option;
import com.sun.webui.jsf.model.SingleSelectOptionsList;
import java.util.ArrayList;
import java.util.List;
import javax.faces.FacesException;
import javax.faces.event.ValueChangeEvent;
import org.hibernate.Session;
import org.hibernate.Transaction;
import py.com.domain.Ciudades;
import py.com.domain.Departamentos;
import py.com.webdav.util.HibernateUtil;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version DropTest.java
 * @version Created on May 12, 2010, 4:45:40 PM
 * @author markos
 */
public class DropTest extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
    }
    private SingleSelectOptionsList dropDown1DefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getDropDown1DefaultOptions() {
        return dropDown1DefaultOptions;
    }

    public void setDropDown1DefaultOptions(SingleSelectOptionsList ssol) {
        this.dropDown1DefaultOptions = ssol;
    }
    private SingleSelectOptionsList dropDown2DefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getDropDown2DefaultOptions() {
        return dropDown2DefaultOptions;
    }

    public void setDropDown2DefaultOptions(SingleSelectOptionsList ssol) {
        this.dropDown2DefaultOptions = ssol;
    }
    private DropDown dropUno = new DropDown();

    public DropDown getDropUno() {
        return dropUno;
    }

    public void setDropUno(DropDown dd) {
        this.dropUno = dd;
    }
    private TextField txtUno = new TextField();

    public TextField getTxtUno() {
        return txtUno;
    }

    public void setTxtUno(TextField tf) {
        this.txtUno = tf;
    }
    private TextField txtDos = new TextField();

    public TextField getTxtDos() {
        return txtDos;
    }

    public void setTxtDos(TextField tf) {
        this.txtDos = tf;
    }
    private DropDown dropDos = new DropDown();

    public DropDown getDropDos() {
        return dropDos;
    }

    public void setDropDos(DropDown dd) {
        this.dropDos = dd;
    }

    // </editor-fold>
    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public DropTest() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here

        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("DropTest Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
        }

        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }
    private List<Option> listaCiudades;
    private List<Option> listaDepartamentos;

    public List<Option> getListaDepartamentos() {
        try {
            Session s = HibernateUtil.getSessionFactory().getCurrentSession();
            Transaction t = s.beginTransaction();
            List<Departamentos> l = s.createQuery("from Departamentos ").list();
            listaDepartamentos = new ArrayList<Option>();
            for (Departamentos d : l) {
                listaDepartamentos.add(new Option(d.getDpDepartamento().toString(), d.getDpDescripcion()));
            }
            t.commit();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return listaDepartamentos;
    }

    public void setListaDepartamentos(List<Option> listaDepartamentos) {
        this.listaDepartamentos = listaDepartamentos;
    }

    public List<Option> getListaCiudades() {
       
        return listaCiudades;
    }

    public void setListaCiudades(List<Option> listaCiudades) {
        this.listaCiudades = listaCiudades;
    }

    public void dropUno_processValueChange(ValueChangeEvent event) {
        try {
            Session s = HibernateUtil.getSessionFactory().getCurrentSession();
            Transaction t = s.beginTransaction();
            String sql = "from Ciudades where ciDepartamento.dpDepartamento = " + dropUno.getSelected().toString();
            System.out.println("[ sql ] : " + sql);
            List<Ciudades> l = s.createQuery(sql).list();
            listaCiudades = new ArrayList<Option>();
            for (Ciudades ciudades : l) {
                System.out.println(ciudades.toString());
                listaCiudades.add(new Option(ciudades.getCiCiudad().toString(), ciudades.getCiDescripcion()));
            }
            t.commit();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void txtUno_processValueChange(ValueChangeEvent event) {
        txtDos.setText(txtUno.getText().toString() + " upd");
    }
}

